CREATE   PROCEDURE [dbo].[asi_PrcQueryPriceSheetListByProduct]
    @productKey uniqueidentifier
    AS
BEGIN
    SELECT ps.PriceSheetKey, ps.Name
    FROM PriceDetail pd
    INNER JOIN PriceVersionDetail pvd ON pd.PriceDetailKey = pvd.PriceDetailKey
    INNER JOIN PriceSheetVersion psv ON pvd.PriceSheetVersionKey = psv.PriceSheetVersionKey
    INNER JOIN PriceSheet ps ON psv.PriceSheetKey = ps.PriceSheetKey
    WHERE pd.ProductKey = @productKey
    ORDER BY ps.Name
END

GO